Caution! If your user-defined table contains customized objects (triggers, additional indexes, special permissions), they will be lost when the table is rebuilt.
1. Make sure all other users exit the iMIS system.
2. Back up your data.
3. Log on as the database owner: MANAGER.
4. From Customers, select Set up module> General, and click Additional Windows to open the Customer Setup – Additional Windows window.
5. Click Define Tables to open the User Defined Tables window.
6. Select the Table Name drop-down list, and select the table you want to modify.
7. Make the necessary changes:
□ To add a field to the table, place the cursor anywhere in the field row where you want the new field to follow, and click Insert Line on the User Defined Tables window. A new field row is inserted, and the new field information can be added here.
□ To delete a field on the table, place the cursor anywhere in the field, and click Delete Line on the User Defined Tables window.
□ To reorder the fields, select the field, and click Up or Down on the User Defined Tables window.
8. Click Save. iMIS prompts you to update the server table.
9. Click Yes.
10. Click OK if prompted to restart iMIS.
11. Click Auto-Create Window.
12. Click Close to close the User Defined Tables window.
13. From Tools > Utilities, select User defined tables. Click to generate business objects from user defined tables.
14. Exit iMIS immediately.
15. (iParts using UD tables) Restart IIS so any new field added to a user defined table is included as available fields in existing iParts.